/**
 * Copyright:  Copyright (c) 2013
 *
 * @FileName		: ProfitAndLossMachineDAOImpl.java
 * @PageName		: 손익현황 - 공장별
 * @Date			: 오전 11:15:31
 * @LastModifier	: 최경민
 * @LastModifyDate	: 
 * @LastModifier	: 
 * Change history	:
 */
package com.pulp.management.dao.impl;

import java.sql.SQLException;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;

import com.pulp.management.dao.ProfitAndLossMachineDAO;
import com.pulp.management.model.ProfitAndLossMachineInfo;

/**
 * The Class ProfitAndLossMachineDAOImpl.
 */
public class ProfitAndLossMachineDAOImpl extends SqlMapClientDaoSupport implements ProfitAndLossMachineDAO {

	/* (non-Javadoc)
	 * @see com.pulp.management.dao.ProfitAndLossDAO#getMachinelInfoList()
	 */
	@SuppressWarnings("unchecked")
	@Override
	public List<ProfitAndLossMachineInfo> getMachinelInfoList() throws SQLException {
		Map mapArgs = new HashMap();
		return getSqlMapClientTemplate().queryForList("manage.MachinelInfoList", mapArgs);
	}

	/* (non-Javadoc)
	 * @see com.pulp.management.dao.ProfitAndLossDAO#getMonthlyInfoList()
	 */
	@SuppressWarnings("unchecked")
	@Override
	public List<ProfitAndLossMachineInfo> getMonthlyInfoList() throws SQLException {
		Map mapArgs = new HashMap();
		return getSqlMapClientTemplate().queryForList("manage.MonthlyInfoList", mapArgs);
	}

	/* (non-Javadoc)
	 * @see com.pulp.management.dao.ProfitAndLossDAO#getTableInfoList()
	 */
	@SuppressWarnings("unchecked")
	@Override
	public List<ProfitAndLossMachineInfo> getTableInfoList() throws SQLException {
		Map mapArgs = new HashMap();
		return getSqlMapClientTemplate().queryForList("manage.TableInfoList", mapArgs);
	}

	/* (non-Javadoc)
	 * @see com.pulp.management.dao.ProfitAndLossDAO#getTotalYearColumnInfoList()
	 */
	@SuppressWarnings("unchecked")
	@Override
	public List<ProfitAndLossMachineInfo> getTotalYearColumnInfoList() throws SQLException {
		Map mapArgs = new HashMap();
		return getSqlMapClientTemplate().queryForList("management.TotalYearColumnInfoList", mapArgs);
	}

	/* (non-Javadoc)
	 * @see com.pulp.management.dao.ProfitAndLossDAO#getTotalYearPieInfoList()
	 */
	@SuppressWarnings("unchecked")
	@Override
	public List<ProfitAndLossMachineInfo> getTotalYearPieInfoList() throws SQLException {
		Map mapArgs = new HashMap();
		return getSqlMapClientTemplate().queryForList("management.TotalYearPieInfoList", mapArgs);
	}
}
